At 12:37 PM -0500 12/1/08, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>> If my perusal of the sql generated by pg_dump is correct, then it
>> doesn't appear that it's wrapped in a transaction, and thus might be
>> able to only complete a partial restore?
>
>That's correct, and intentional. You can use pg_restore's -1 switch
>or add begin/end manually if you don't want it to work that way.
>
> regards, tom lane
Thanks to everybody for their help. You guys are great.
-Owen